package com.zero.yygh.hosp.service.impl;

import com.alibaba.excel.util.CollectionUtils;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.zero.yygh.common.exception.CommonException;
import com.zero.yygh.common.result.ResultCodeEnum;
import com.zero.yygh.common.util.DateUtil;
import com.zero.yygh.hosp.repository.ScheduleRepository;
import com.zero.yygh.hosp.service.DepartmentService;
import com.zero.yygh.hosp.service.HospitalService;
import com.zero.yygh.hosp.service.ScheduleService;
import com.zero.yygh.model.hosp.BookingRule;
import com.zero.yygh.model.hosp.Department;
import com.zero.yygh.model.hosp.Hospital;
import com.zero.yygh.model.hosp.Schedule;
import com.zero.yygh.vo.hosp.BookingScheduleRuleVo;
import com.zero.yygh.vo.hosp.ScheduleOrderVo;
import com.zero.yygh.vo.hosp.ScheduleQueryVo;
import lombok.extern.slf4j.Slf4j;
import org.joda.time.DateTime;
import org.joda.time.format.DateTimeFormat;
import org.springframework.beans.BeanUtils;
import org.springframework.data.domain.*;
import org.springframework.data.mongodb.core.MongoTemplate;
import org.springframework.data.mongodb.core.aggregation.Aggregation;
import org.springframework.data.mongodb.core.aggregation.AggregationResults;
import org.springframework.data.mongodb.core.query.Criteria;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.*;
import java.util.stream.Collector;
import java.util.stream.Collectors;

/**
 * @author zero
 * @desc
 * @create 2021/3/27
 */
@Service
@Slf4j
public class ScheduleServiceImpl implements ScheduleService {

  @Resource
  private ScheduleRepository scheduleRepository;
  @Resource
  private MongoTemplate mongoTemplate;
  @Resource
  private HospitalService hospitalService;
  @Resource
  private DepartmentService departmentService;

  /**
   * 保存排班信息
   *
   * @param paramMap 排班参数
   * @author zero
   * @date 2021/3/27 21:12
   */
  @Override
  public void save(Map<String, Object> paramMap) {
    Schedule schedule = JSONObject.parseObject(JSONObject.toJSONString(paramMap), Schedule.class);
    Schedule targetSchedule =
        scheduleRepository.getScheduleByHoscodeAndHosScheduleId(
            schedule.getHoscode(), schedule.getHosScheduleId());
    if (null != targetSchedule) {
      // 值copy不为null的值，该方法为自定义方法
      BeanUtils.copyProperties(schedule, targetSchedule, Schedule.class);
      scheduleRepository.save(targetSchedule);
    } else {
      schedule.setCreateTime(new Date());
      schedule.setUpdateTime(new Date());
      schedule.setIsDeleted(0);
      scheduleRepository.save(schedule);
    }
  }

    /**
     * @param page            当前页
     * @param limit           每页数据
     * @param scheduleQueryVo 查询条件
     * @return org.springframework.data.domain.Page<com.zero.yygh.model.hosp.Schedule>
     * @author zero
     * @date 2021/3/27 21:19
     */
    @Override
    public Page<Schedule> selectPage (Integer page, Integer limit, ScheduleQueryVo scheduleQueryVo) {
        Sort sort = Sort.by(Sort.Direction.DESC, "createTime");
        //0为第一页
        Pageable pageable = PageRequest.of(page-1, limit, sort);

        Schedule schedule = new Schedule();
        BeanUtils.copyProperties(scheduleQueryVo, schedule);
        schedule.setIsDeleted(0);

        //创建匹配器，即如何使用查询条件
        //构建对象
        ExampleMatcher matcher = ExampleMatcher.matching()
                //改变默认字符串匹配方式：模糊查询
                .withStringMatcher(ExampleMatcher.StringMatcher.CONTAINING)
                //改变默认大小写忽略方式：忽略大小写
                .withIgnoreCase(true);

        //创建实例
        Example<Schedule> example = Example.of(schedule, matcher);
        return scheduleRepository.findAll(example, pageable);

    }

    /**
     * 根据医院编号与排班编号删除科室
     * @param hoscode       医院编号
     * @param hosScheduleId 排班id
     * @author zero
     * @date 2021/3/27 21:23
     */
    @Override
    public void remove (String hoscode, String hosScheduleId) {
        Schedule schedule = scheduleRepository.getScheduleByHoscodeAndHosScheduleId(hoscode,
                hosScheduleId);
        if (schedule != null) {
            scheduleRepository.deleteById(schedule.getId());
        }
    }

    /**
     * 根据医院编号 和 科室编号 ，查询排班规则数据
     * @param page    当前页数
     * @param limit   每页数据
     * @param hoscode 医院编号
     * @param depcode 科室编号
     * @return java.util.Map<java.lang.String, java.lang.Object>
     * @author zero
     * @date 2021/3/30 13:18
     */
    @Override
    public Map<String, Object> getRuleSchedule (long page, long limit, String hoscode, String depcode) {
        //1 根据医院编号 和 科室编号 查询
        Criteria criteria = Criteria.where("hoscode").is(hoscode).and("depcode").is(depcode);

        //2 根据工作日workDate期进行分组
        Aggregation agg = Aggregation.newAggregation(
                //匹配条件
                Aggregation.match(criteria),
                //分组字段
                Aggregation.group("workDate")
                        .first("workDate").as("workDate")
                        //3 统计号源数量
                        .count().as("docCount")
                        .sum("reservedNumber").as("reservedNumber")
                        .sum("availableNumber").as("availableNumber"),
                //排序
                Aggregation.sort(Sort.Direction.DESC,"workDate"),
                //4 实现分页
                Aggregation.skip((page-1)*limit),
                Aggregation.limit(limit)
        );
        //调用方法，最终执行
        AggregationResults<BookingScheduleRuleVo> aggResults =
                mongoTemplate.aggregate(agg, Schedule.class, BookingScheduleRuleVo.class);
        List<BookingScheduleRuleVo> bookingScheduleRuleVoList = aggResults.getMappedResults();

        //分组查询的总记录数
        Aggregation totalAgg = Aggregation.newAggregation(
                Aggregation.match(criteria),
                Aggregation.group("workDate")
        );
        AggregationResults<BookingScheduleRuleVo> totalAggResults =
                mongoTemplate.aggregate(totalAgg,
                        Schedule.class, BookingScheduleRuleVo.class);
        int total = totalAggResults.getMappedResults().size();

        //把日期对应星期获取
        for(BookingScheduleRuleVo bookingScheduleRuleVo:bookingScheduleRuleVoList) {
            Date workDate = bookingScheduleRuleVo.getWorkDate();
            String dayOfWeek = DateUtil.getDayOfWeek(new DateTime(workDate));
            bookingScheduleRuleVo.setDayOfWeek(dayOfWeek);
        }

        //设置最终数据，进行返回
        Map<String, Object> result = new HashMap<>();
        result.put("bookingScheduleRuleList",bookingScheduleRuleVoList);
        result.put("total",total);

        //获取医院名称
        String hosName = hospitalService.getHospName(hoscode);
        //其他基础数据
        Map<String, String> baseMap = new HashMap<>(1);
        baseMap.put("hosname",hosName);
        result.put("baseMap",baseMap);

        return result;
    }

    /**
     * 根据医院编号 、科室编号和工作日期，查询排班详细信息
     * @param hoscode  医院编号
     * @param depcode  科室编号
     * @param workDate 工作日期
     * @return java.util.List<com.zero.yygh.model.hosp.Schedule>
     * @author zero
     * @date 2021/3/30 14:01
     */
    @Override
    public List<Schedule> getDetailSchedule (String hoscode, String depcode, String workDate) {
        //根据参数查询mongodb
        List<Schedule> scheduleList =
                scheduleRepository.findScheduleByHoscodeAndDepcodeAndWorkDate(hoscode,depcode,new DateTime(workDate).toDate());
        //把得到list集合遍历，向设置其他值：医院名称、科室名称、日期对应星期
        scheduleList.forEach(this::packageSchedule);
        return scheduleList;
    }

    /**
     * 分页获取排班可预约日期数据
     * @author zero
     * @date 2021/4/20 13:04
     * @param page 当前页
     * @param limit 每页数据条数
     * @param hoscode 医院编号
     * @param depcode 部门编号
     * @return java.util.Map<java.lang.String,java.lang.Object>
     */
    @Override
    public Map<String, Object> getBookingScheduleRule (int page, int limit, String hoscode, String depcode) {

        Map<String, Object> result = new HashMap<>(3);
        // 获取预约规则
        Hospital hospital = hospitalService.getByHoscode(hoscode);
        if (null == hospital) {
            throw new CommonException(ResultCodeEnum.DATA_ERROR);
        }
        BookingRule bookingRule = hospital.getBookingRule();
        // 获取可预约日期
        IPage<Date> iPage = this.getListDate(page, limit, bookingRule);
        // 当前页可预约日期
        List<Date> dateList = iPage.getRecords();
        // 获取可预约日期科室剩余预约数
        Criteria criteria = Criteria.where("hoscode").is(hoscode).and("depcode").is(depcode).and("workDate").in(dateList);
        Aggregation aggregation = Aggregation.newAggregation(
                Aggregation.match(criteria),
                // 分组字段
                Aggregation.group("workDate")
                        .first("workDate").as("workDate")
                        .count().as("docCount")
                        .sum("availableNumber").as("availableNumber")
                        .sum("reservedNumber").as("reservedNumber")
        );

        AggregationResults<BookingScheduleRuleVo> aggregationResults = mongoTemplate.aggregate(aggregation, Schedule.class, BookingScheduleRuleVo.class);
        List<BookingScheduleRuleVo> scheduleRuleVoList = aggregationResults.getMappedResults();
        // 获取科室剩余预约数
        // 合并数据 将统计数据 ScheduleVo 根据 安排日期 合并到 BookingRuleVo
        Map<Date, BookingScheduleRuleVo> scheduleRuleVoMap = new HashMap<>();
        if (!CollectionUtils.isEmpty(scheduleRuleVoList)) {
            scheduleRuleVoMap = scheduleRuleVoList.stream().collect(Collectors.toMap(BookingScheduleRuleVo :: getWorkDate, BookingScheduleRuleVo -> BookingScheduleRuleVo));
        }
        // 获取排班可预约规则
        List<BookingScheduleRuleVo> bookingScheduleRuleVoList = new ArrayList<>();
        for (int i = 0, len = dateList.size() ; i < len; i++) {
            Date date = dateList.get(i);
            BookingScheduleRuleVo bookingScheduleRuleVo = scheduleRuleVoMap.get(date);
            if (null == bookingScheduleRuleVo) {
                // 当天没有排班医生
                bookingScheduleRuleVo = new BookingScheduleRuleVo();
                // 就诊医生人数
                bookingScheduleRuleVo.setDocCount(0);
                // 科室剩余预约数 -1 表示无号
                bookingScheduleRuleVo.setAvailableNumber(-1);
            }
            bookingScheduleRuleVo.setWorkDate(date);
            bookingScheduleRuleVo.setWorkDateMd(date);
            // 计算当前预约日期为周几
            String dayOfWeek = DateUtil.getDayOfWeek(new DateTime(date));
            bookingScheduleRuleVo.setDayOfWeek(dayOfWeek);
            //  最后一页最后一条记录为即将预约 状态为 0：正常 1：即将放号 -1：当天停止挂号
            if(i == len - 1 && page == iPage.getPages()){
                bookingScheduleRuleVo.setStatus(1);
            }else {
                bookingScheduleRuleVo.setStatus(0);
            }
            // 如果当前过了停好时间
            if(i == 0 && page == 1) {
                DateTime stopTime = this.getDateTime(new Date(), bookingRule.getStopTime());
                if (stopTime.isBeforeNow()) {
                    // 停止预约
                    bookingScheduleRuleVo.setStatus(-1);
                }
            }
            bookingScheduleRuleVoList.add(bookingScheduleRuleVo);
        }

        // 可预约日期规则数据
        result.put("bookingScheduleList", bookingScheduleRuleVoList);
        result.put("total", iPage.getTotal());
        //其他基础数据
        Map<String, String> baseMap = new HashMap<>(5);
        //医院名称
        baseMap.put("hosname", hospitalService.getHospName(hoscode));
        //科室
        Department department = departmentService.getDepartment(hoscode, depcode);
        //大科室名称
        baseMap.put("bigname", department.getBigname());
        //科室名称
        baseMap.put("depname", department.getDepname());
        //月
        baseMap.put("workDateString", new DateTime().toString("yyyy年MM月"));
        //放号时间
        baseMap.put("releaseTime", bookingRule.getReleaseTime());
        //停号时间
        baseMap.put("stopTime", bookingRule.getStopTime());
        result.put("baseMap", baseMap);
        return result;

    }

    /**
     * 根据Id获取排班
     * @param id id
     * @return com.zero.yygh.model.hosp.Schedule
     * @author zero
     * @date 2021/5/8 12:53
     */
    @Override
    public Schedule getById (String id) {
        Schedule schedule = scheduleRepository.findById(id).get();
        return this.packageSchedule(schedule);
    }

    /**
     * 根据排班ID获取预约下单数据
     * @param scheduleId 排班ID
     * @return com.zero.yygh.vo.hosp.ScheduleOrderVo
     * @author zero
     * @date 2021/5/8 15:23
     */
    @Override
    public ScheduleOrderVo getScheduleOrderVo (String scheduleId) {
        ScheduleOrderVo scheduleOrderVo = new ScheduleOrderVo();
        // 排班信息
        Schedule schedule = scheduleRepository.findById(scheduleId).get();
        // 获取预约规则
        Hospital hospital = hospitalService.getByHoscode(schedule.getHoscode());
        if(null == hospital) {
            throw new CommonException(ResultCodeEnum.DATA_ERROR);
        }
        BookingRule bookingRule = hospital.getBookingRule();
        if(null == bookingRule){
            throw new CommonException(ResultCodeEnum.PARAM_ERROR);
        }
        scheduleOrderVo.setHoscode(schedule.getHoscode());
        scheduleOrderVo.setHosname(hospitalService.getHospName(schedule.getHoscode()));
        scheduleOrderVo.setDepcode(schedule.getDepcode());
        scheduleOrderVo.setDepname(departmentService.getDepName(schedule.getHoscode(), schedule.getDepcode()));
        scheduleOrderVo.setHosScheduleId(schedule.getHosScheduleId());
        scheduleOrderVo.setAvailableNumber(schedule.getAvailableNumber());
        scheduleOrderVo.setTitle(schedule.getTitle());
        scheduleOrderVo.setReserveDate(schedule.getWorkDate());
        scheduleOrderVo.setReserveTime(schedule.getWorkTime());
        scheduleOrderVo.setAmount(schedule.getAmount());
        //退号截止天数（如：就诊前一天为-1，当天为0）
        Integer quitDay = bookingRule.getQuitDay();
        DateTime quitTime = this.getDateTime(new DateTime(schedule.getWorkDate()).plusDays(quitDay).toDate(), bookingRule.getQuitTime());
        scheduleOrderVo.setQuitTime(quitTime.toDate());
        // 预约开始时间
        DateTime startTime = this.getDateTime(new Date(), bookingRule.getReleaseTime());
        scheduleOrderVo.setStartTime(startTime.toDate());
        // 预约截止时间
        DateTime endTime = this.getDateTime(new DateTime().plusDays(bookingRule.getCycle()).toDate(), bookingRule.getStopTime());
        scheduleOrderVo.setEndTime(endTime.toDate());
        // 当天停止挂号时间
        DateTime stopTime = this.getDateTime(new Date(), bookingRule.getStopTime());
        scheduleOrderVo.setStopTime(stopTime.toDate());
        return scheduleOrderVo;
    }

    /**
     * 更新排班信息
     * @param schedule 排班信息
     * @author zero
     * @date 2021/5/10 10:45
     */
    @Override
    public void update (Schedule schedule) {
        schedule.setUpdateTime(new Date());
        // 此处主键一致则是保存，否则为添加
        scheduleRepository.save(schedule);
    }

    /**
     * 获取可以预约日期分页数据
     * @author zero
     * @date 2021/4/20 13:12
     * @param page 当前页
     * @param limit 每页数据条数
     * @param bookingRule 预约规则数据
     * @return com.baomidou.mybatisplus.core.metadata.IPage<java.util.Date>
     */
    private IPage<Date> getListDate (int page, int limit, BookingRule bookingRule) {
        // 计算当天放号时间
        DateTime releaseTime = this.getDateTime(new Date(), bookingRule.getReleaseTime());
        // 预约周期
        int cycle = bookingRule.getCycle();
        // 如果当天放号时间已过，则预约周期后一天为即将放号时间，周期 +1
        if (releaseTime.isBeforeNow()) {
            cycle += 1;
        }
        // 可预约所有日期，最后一天显示即将放号倒计时
        List<Date> dateList = new ArrayList<>();
        for (int i = 0; i < cycle; i++) {
            // 计算当前预约日期
            DateTime curDateTime = new DateTime().plusDays(i);
            String dateString = curDateTime.toString("yyyy-MM-dd");
            dateList.add(new DateTime(dateString).toDate());
        }
        //日期分页，由于预约周期不一样，页面一排最多显示7天数据，多了就要分页显示
        List<Date> pageDateList = new ArrayList<>();
        int start = (page - 1) * limit;
        int end = page * limit;
        if (end > dateList.size()) {
            end = dateList.size();
        }
        for (int i = start; i < end; i++) {
            pageDateList.add(dateList.get(i));
        }
        IPage<Date> iPage = new com.baomidou.mybatisplus.extension.plugins.pagination.Page<>(page, 7, dateList.size());
        iPage.setRecords(pageDateList);
        return iPage;
    }

    /**
     * 将Date日期（yyyy-MM-dd HH:mm）转换为DateTime
     * @author zero
     * @date 2021/4/20 13:15
     * @param date 日期
     * @param releaseTime 时间
     * @return org.joda.time.DateTime
     */
    private DateTime getDateTime (Date date, String releaseTime) {
        String dateTimeString = new DateTime(date).toString("yyyy-MM-dd") + " " + releaseTime;
        return DateTimeFormat.forPattern("yyyy-MM-dd HH:ss").parseDateTime(dateTimeString);
    }

    /**
   * 封装排班详情其他值 医院名称、科室名称、日期对应星期
   * @author zero
   * @date 2021/3/30 14:03
   * @param schedule 工作日期
   */
  private Schedule packageSchedule(Schedule schedule) {
        //设置医院名称
        schedule.getParam().put("hosname",hospitalService.getHospName(schedule.getHoscode()));
        //设置科室名称
        schedule.getParam().put("depname",departmentService.getDepName(schedule.getHoscode(),schedule.getDepcode()));
        //设置日期对应星期
        schedule.getParam().put("dayOfWeek",DateUtil.getDayOfWeek(new DateTime(schedule.getWorkDate())));
        return schedule;
    }
}
